![[Jenkins]](/kapua/static/bc58d2fb/images/svgs/logo.svg){kind=logo}
Failed
Scenario: Find user by name.Scenario: Find user by name (from org.eclipse.kapua.service.user.internal.RunTest)
Failing for the past 1 build
(Since Unstable
)
Error Message
liquibase.exception.MigrationFailedException: Migration failed for change set KapuaDB/changelog-account-0.2.0.xml::changelog-account-0.2.0_createTable::eurotech:
Reason: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE PUBLIC.act_account (scope_id BIGINT(21) unsigned, id BIGINT(21) unsigned NOT NULL, name VARCHAR(255) NOT NULL, created_on TIMESTAMP DEFAULT NOW(), created_by BIGINT(21) unsigned NOT NULL, modified_on TIMESTAMP DEFAULT NOW() NOT NULL, modified_by BIGINT(21) unsigned NOT NULL, org_name VARCHAR(255) NOT NULL, org_person_name VARCHAR(255), org_email VARCHAR(255) NOT NULL, org_phone_number VARCHAR(64), org_address_line_1 VARCHAR(255), org_address_line_2 VARCHAR(255), org_address_line_3 VARCHAR(255), org_zip_postcode VARCHAR(255), org_city VARCHAR(255), org_state_province_county VARCHAR(255), org_country VARCHAR(255), parent_account_path VARCHAR(64), optlock INT unsigned, attributes CLOB, properties CLOB, CONSTRAINT PK_ACT_ACCOUNT PRIMARY KEY (id), UNIQUE (name)): Table "ACT_ACCOUNT" already exists; SQL statement:
CREATE TABLE PUBLIC.act_account (scope_id BIGINT(21) unsigned, id BIGINT(21) unsigned NOT NULL, name VARCHAR(255) NOT NULL, created_on TIMESTAMP DEFAULT NOW(), created_by BIGINT(21) unsigned NOT NULL, modified_on TIMESTAMP DEFAULT NOW() NOT NULL, modified_by BIGINT(21) unsigned NOT NULL, org_name VARCHAR(255) NOT NULL, org_person_name VARCHAR(255), org_email VARCHAR(255) NOT NULL, org_phone_number VARCHAR(64), org_address_line_1 VARCHAR(255), org_address_line_2 VARCHAR(255), org_address_line_3 VARCHAR(255), org_zip_postcode VARCHAR(255), org_city VARCHAR(255), org_state_province_county VARCHAR(255), org_country VARCHAR(255), parent_account_path VARCHAR(64), optlock INT unsigned, attributes CLOB, properties CLOB, CONSTRAINT PK_ACT_ACCOUNT PRIMARY KEY (id), UNIQUE (name)) [42101-192]Stacktrace
java.lang.RuntimeException:
liquibase.exception.MigrationFailedException: Migration failed for change set KapuaDB/changelog-account-0.2.0.xml::changelog-account-0.2.0_createTable::eurotech:
Reason: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE PUBLIC.act_account (scope_id BIGINT(21) unsigned, id BIGINT(21) unsigned NOT NULL, name VARCHAR(255) NOT NULL, created_on TIMESTAMP DEFAULT NOW(), created_by BIGINT(21) unsigned NOT NULL, modified_on TIMESTAMP DEFAULT NOW() NOT NULL, modified_by BIGINT(21) unsigned NOT NULL, org_name VARCHAR(255) NOT NULL, org_person_name VARCHAR(255), org_email VARCHAR(255) NOT NULL, org_phone_number VARCHAR(64), org_address_line_1 VARCHAR(255), org_address_line_2 VARCHAR(255), org_address_line_3 VARCHAR(255), org_zip_postcode VARCHAR(255), org_city VARCHAR(255), org_state_province_county VARCHAR(255), org_country VARCHAR(255), parent_account_path VARCHAR(64), optlock INT unsigned, attributes CLOB, properties CLOB, CONSTRAINT PK_ACT_ACCOUNT PRIMARY KEY (id), UNIQUE (name)): Table "ACT_ACCOUNT" already exists; SQL statement:
CREATE TABLE PUBLIC.act_account (scope_id BIGINT(21) unsigned, id BIGINT(21) unsigned NOT NULL, name VARCHAR(255) NOT NULL, created_on TIMESTAMP DEFAULT NOW(), created_by BIGINT(21) unsigned NOT NULL, modified_on TIMESTAMP DEFAULT NOW() NOT NULL, modified_by BIGINT(21) unsigned NOT NULL, org_name VARCHAR(255) NOT NULL, org_person_name VARCHAR(255), org_email VARCHAR(255) NOT NULL, org_phone_number VARCHAR(64), org_address_line_1 VARCHAR(255), org_address_line_2 VARCHAR(255), org_address_line_3 VARCHAR(255), org_zip_postcode VARCHAR(255), org_city VARCHAR(255), org_state_province_county VARCHAR(255), org_country VARCHAR(255), parent_account_path VARCHAR(64), optlock INT unsigned, attributes CLOB, properties CLOB, CONSTRAINT PK_ACT_ACCOUNT PRIMARY KEY (id), UNIQUE (name)) [42101-192]
Caused by: liquibase.exception.MigrationFailedException:
Migration failed for change set KapuaDB/changelog-account-0.2.0.xml::changelog-account-0.2.0_createTable::eurotech:
Reason: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE PUBLIC.act_account (scope_id BIGINT(21) unsigned, id BIGINT(21) unsigned NOT NULL, name VARCHAR(255) NOT NULL, created_on TIMESTAMP DEFAULT NOW(), created_by BIGINT(21) unsigned NOT NULL, modified_on TIMESTAMP DEFAULT NOW() NOT NULL, modified_by BIGINT(21) unsigned NOT NULL, org_name VARCHAR(255) NOT NULL, org_person_name VARCHAR(255), org_email VARCHAR(255) NOT NULL, org_phone_number VARCHAR(64), org_address_line_1 VARCHAR(255), org_address_line_2 VARCHAR(255), org_address_line_3 VARCHAR(255), org_zip_postcode VARCHAR(255), org_city VARCHAR(255), org_state_province_county VARCHAR(255), org_country VARCHAR(255), parent_account_path VARCHAR(64), optlock INT unsigned, attributes CLOB, properties CLOB, CONSTRAINT PK_ACT_ACCOUNT PRIMARY KEY (id), UNIQUE (name)): Table "ACT_ACCOUNT" already exists; SQL statement:
CREATE TABLE PUBLIC.act_account (scope_id BIGINT(21) unsigned, id BIGINT(21) unsigned NOT NULL, name VARCHAR(255) NOT NULL, created_on TIMESTAMP DEFAULT NOW(), created_by BIGINT(21) unsigned NOT NULL, modified_on TIMESTAMP DEFAULT NOW() NOT NULL, modified_by BIGINT(21) unsigned NOT NULL, org_name VARCHAR(255) NOT NULL, org_person_name VARCHAR(255), org_email VARCHAR(255) NOT NULL, org_phone_number VARCHAR(64), org_address_line_1 VARCHAR(255), org_address_line_2 VARCHAR(255), org_address_line_3 VARCHAR(255), org_zip_postcode VARCHAR(255), org_city VARCHAR(255), org_state_province_county VARCHAR(255), org_country VARCHAR(255), parent_account_path VARCHAR(64), optlock INT unsigned, attributes CLOB, properties CLOB, CONSTRAINT PK_ACT_ACCOUNT PRIMARY KEY (id), UNIQUE (name)) [42101-192]
Caused by: liquibase.exception.DatabaseException:
Error executing SQL CREATE TABLE PUBLIC.act_account (scope_id BIGINT(21) unsigned, id BIGINT(21) unsigned NOT NULL, name VARCHAR(255) NOT NULL, created_on TIMESTAMP DEFAULT NOW(), created_by BIGINT(21) unsigned NOT NULL, modified_on TIMESTAMP DEFAULT NOW() NOT NULL, modified_by BIGINT(21) unsigned NOT NULL, org_name VARCHAR(255) NOT NULL, org_person_name VARCHAR(255), org_email VARCHAR(255) NOT NULL, org_phone_number VARCHAR(64), org_address_line_1 VARCHAR(255), org_address_line_2 VARCHAR(255), org_address_line_3 VARCHAR(255), org_zip_postcode VARCHAR(255), org_city VARCHAR(255), org_state_province_county VARCHAR(255), org_country VARCHAR(255), parent_account_path VARCHAR(64), optlock INT unsigned, attributes CLOB, properties CLOB, CONSTRAINT PK_ACT_ACCOUNT PRIMARY KEY (id), UNIQUE (name)): Table "ACT_ACCOUNT" already exists; SQL statement:
CREATE TABLE PUBLIC.act_account (scope_id BIGINT(21) unsigned, id BIGINT(21) unsigned NOT NULL, name VARCHAR(255) NOT NULL, created_on TIMESTAMP DEFAULT NOW(), created_by BIGINT(21) unsigned NOT NULL, modified_on TIMESTAMP DEFAULT NOW() NOT NULL, modified_by BIGINT(21) unsigned NOT NULL, org_name VARCHAR(255) NOT NULL, org_person_name VARCHAR(255), org_email VARCHAR(255) NOT NULL, org_phone_number VARCHAR(64), org_address_line_1 VARCHAR(255), org_address_line_2 VARCHAR(255), org_address_line_3 VARCHAR(255), org_zip_postcode VARCHAR(255), org_city VARCHAR(255), org_state_province_county VARCHAR(255), org_country VARCHAR(255), parent_account_path VARCHAR(64), optlock INT unsigned, attributes CLOB, properties CLOB, CONSTRAINT PK_ACT_ACCOUNT PRIMARY KEY (id), UNIQUE (name)) [42101-192]
Caused by: org.h2.jdbc.JdbcSQLException:
Table "ACT_ACCOUNT" already exists; SQL statement:
CREATE TABLE PUBLIC.act_account (scope_id BIGINT(21) unsigned, id BIGINT(21) unsigned NOT NULL, name VARCHAR(255) NOT NULL, created_on TIMESTAMP DEFAULT NOW(), created_by BIGINT(21) unsigned NOT NULL, modified_on TIMESTAMP DEFAULT NOW() NOT NULL, modified_by BIGINT(21) unsigned NOT NULL, org_name VARCHAR(255) NOT NULL, org_person_name VARCHAR(255), org_email VARCHAR(255) NOT NULL, org_phone_number VARCHAR(64), org_address_line_1 VARCHAR(255), org_address_line_2 VARCHAR(255), org_address_line_3 VARCHAR(255), org_zip_postcode VARCHAR(255), org_city VARCHAR(255), org_state_province_county VARCHAR(255), org_country VARCHAR(255), parent_account_path VARCHAR(64), optlock INT unsigned, attributes CLOB, properties CLOB, CONSTRAINT PK_ACT_ACCOUNT PRIMARY KEY (id), UNIQUE (name)) [42101-192]
Standard Output
06:27:43.606 [main] INFO o.e.k.c.jpa.SimpleSqlScriptExecutor - Running script: RUNSCRIPT FROM 'src/main/sql/H2/usr_user_drop.sql'
06:27:43.608 [main] INFO o.e.k.c.c.KapuaConfigurableServiceSchemaUtils - Running database scripts...
06:27:43.609 [main] INFO o.e.k.c.jpa.SimpleSqlScriptExecutor - Running script: RUNSCRIPT FROM '../../../commons/src/main/sql/H2/sys_configuration_drop.sql'
06:27:43.610 [main] INFO o.e.k.c.jpa.SimpleSqlScriptExecutor - Running script: RUNSCRIPT FROM '../../../commons/src/main/sql/H2/sys_service_event_drop.sql'
06:27:43.611 [main] INFO o.e.k.c.c.KapuaConfigurableServiceSchemaUtils - ...database scripts done!
06:27:43.612 [main] INFO org.eclipse.kapua.test.MockedLocator - Geting mocked service org.eclipse.kapua.service.user.UserService from MockedLocator
06:27:43.612 [main] INFO org.eclipse.kapua.test.MockedLocator - Geting mocked factory org.eclipse.kapua.service.user.UserFactory from MockedLocator
06:27:43.622 [main] INFO org.reflections.Reflections - Reflections took 4 ms to scan 4 urls, producing 733 keys and 737 values
06:27:43.636 [main] INFO o.e.k.s.l.KapuaLiquibaseClient - Executing pre master files...
06:27:43.637 [main] INFO o.e.k.s.l.KapuaLiquibaseClient - Master Liquibase files found: 2
06:27:43.637 [main] INFO o.e.k.s.l.KapuaLiquibaseClient - Excuting liquibase script: /tmp/genie.kapua/kapua-liquibase/changelog-event-store-master.pre.xml
06:27:43.680 [main] INFO o.e.k.s.l.KapuaLiquibaseClient - Excuting liquibase script: /tmp/genie.kapua/kapua-liquibase/changelog-system-configurations-master.pre.xml
06:27:43.744 [main] INFO o.e.k.s.l.KapuaLiquibaseClient - Executing pre master files... DONE!
06:27:43.744 [main] INFO o.e.k.s.l.KapuaLiquibaseClient - Executing master files...
06:27:43.744 [main] INFO o.e.k.s.l.KapuaLiquibaseClient - Master Liquibase files found: 5
06:27:43.744 [main] INFO o.e.k.s.l.KapuaLiquibaseClient - Excuting liquibase script: /tmp/genie.kapua/kapua-liquibase/changelog-account-master.xml
06:27:43.839 [main] ERROR liquibase - Change Set KapuaDB/changelog-account-0.2.0.xml::changelog-account-0.2.0_createTable::eurotech failed. Error: Error executing SQL CREATE TABLE PUBLIC.act_account (scope_id BIGINT(21) unsigned, id BIGINT(21) unsigned NOT NULL, name VARCHAR(255) NOT NULL, created_on TIMESTAMP DEFAULT NOW(), created_by BIGINT(21) unsigned NOT NULL, modified_on TIMESTAMP DEFAULT NOW() NOT NULL, modified_by BIGINT(21) unsigned NOT NULL, org_name VARCHAR(255) NOT NULL, org_person_name VARCHAR(255), org_email VARCHAR(255) NOT NULL, org_phone_number VARCHAR(64), org_address_line_1 VARCHAR(255), org_address_line_2 VARCHAR(255), org_address_line_3 VARCHAR(255), org_zip_postcode VARCHAR(255), org_city VARCHAR(255), org_state_province_county VARCHAR(255), org_country VARCHAR(255), parent_account_path VARCHAR(64), optlock INT unsigned, attributes CLOB, properties CLOB, CONSTRAINT PK_ACT_ACCOUNT PRIMARY KEY (id), UNIQUE (name)): Table "ACT_ACCOUNT" already exists; SQL statement:
CREATE TABLE PUBLIC.act_account (scope_id BIGINT(21) unsigned, id BIGINT(21) unsigned NOT NULL, name VARCHAR(255) NOT NULL, created_on TIMESTAMP DEFAULT NOW(), created_by BIGINT(21) unsigned NOT NULL, modified_on TIMESTAMP DEFAULT NOW() NOT NULL, modified_by BIGINT(21) unsigned NOT NULL, org_name VARCHAR(255) NOT NULL, org_person_name VARCHAR(255), org_email VARCHAR(255) NOT NULL, org_phone_number VARCHAR(64), org_address_line_1 VARCHAR(255), org_address_line_2 VARCHAR(255), org_address_line_3 VARCHAR(255), org_zip_postcode VARCHAR(255), org_city VARCHAR(255), org_state_province_county VARCHAR(255), org_country VARCHAR(255), parent_account_path VARCHAR(64), optlock INT unsigned, attributes CLOB, properties CLOB, CONSTRAINT PK_ACT_ACCOUNT PRIMARY KEY (id), UNIQUE (name)) [42101-192]
liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE PUBLIC.act_account (scope_id BIGINT(21) unsigned, id BIGINT(21) unsigned NOT NULL, name VARCHAR(255) NOT NULL, created_on TIMESTAMP DEFAULT NOW(), created_by BIGINT(21) unsigned NOT NULL, modified_on TIMESTAMP DEFAULT NOW() NOT NULL, modified_by BIGINT(21) unsigned NOT NULL, org_name VARCHAR(255) NOT NULL, org_person_name VARCHAR(255), org_email VARCHAR(255) NOT NULL, org_phone_number VARCHAR(64), org_address_line_1 VARCHAR(255), org_address_line_2 VARCHAR(255), org_address_line_3 VARCHAR(255), org_zip_postcode VARCHAR(255), org_city VARCHAR(255), org_state_province_county VARCHAR(255), org_country VARCHAR(255), parent_account_path VARCHAR(64), optlock INT unsigned, attributes CLOB, properties CLOB, CONSTRAINT PK_ACT_ACCOUNT PRIMARY KEY (id), UNIQUE (name)): Table "ACT_ACCOUNT" already exists; SQL statement:
CREATE TABLE PUBLIC.act_account (scope_id BIGINT(21) unsigned, id BIGINT(21) unsigned NOT NULL, name VARCHAR(255) NOT NULL, created_on TIMESTAMP DEFAULT NOW(), created_by BIGINT(21) unsigned NOT NULL, modified_on TIMESTAMP DEFAULT NOW() NOT NULL, modified_by BIGINT(21) unsigned NOT NULL, org_name VARCHAR(255) NOT NULL, org_person_name VARCHAR(255), org_email VARCHAR(255) NOT NULL, org_phone_number VARCHAR(64), org_address_line_1 VARCHAR(255), org_address_line_2 VARCHAR(255), org_address_line_3 VARCHAR(255), org_zip_postcode VARCHAR(255), org_city VARCHAR(255), org_state_province_county VARCHAR(255), org_country VARCHAR(255), parent_account_path VARCHAR(64), optlock INT unsigned, attributes CLOB, properties CLOB, CONSTRAINT PK_ACT_ACCOUNT PRIMARY KEY (id), UNIQUE (name)) [42101-192]
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:56)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:98)
at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1491)
at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1474)
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:343)
at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:40)
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:63)
at liquibase.Liquibase.update(Liquibase.java:136)
at org.eclipse.kapua.service.liquibase.KapuaLiquibaseClient.executeMasters(KapuaLiquibaseClient.java:136)
at org.eclipse.kapua.service.liquibase.KapuaLiquibaseClient.loadResourcesStatic(KapuaLiquibaseClient.java:112)
at org.eclipse.kapua.service.liquibase.KapuaLiquibaseClient.update(KapuaLiquibaseClient.java:67)
at org.eclipse.kapua.service.user.internal.UserServiceSteps.beforeScenario(UserServiceSteps.java:209)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at cucumber.runtime.Utils$1.call(Utils.java:37)
at cucumber.runtime.Timeout.timeout(Timeout.java:13)
at cucumber.runtime.Utils.invoke(Utils.java:31)
at cucumber.runtime.java.JavaHookDefinition.execute(JavaHookDefinition.java:60)
at cucumber.runtime.Runtime.runHookIfTagsMatch(Runtime.java:223)
at cucumber.runtime.Runtime.runHooks(Runtime.java:211)
at cucumber.runtime.Runtime.runBeforeHooks(Runtime.java:201)
at cucumber.runtime.model.CucumberScenario.run(CucumberScenario.java:40)
at cucumber.runtime.junit.ExecutionUnitRunner.run(ExecutionUnitRunner.java:91)
at cucumber.runtime.junit.FeatureRunner.runChild(FeatureRunner.java:63)
at cucumber.runtime.junit.FeatureRunner.runChild(FeatureRunner.java:18)
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:238)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:63)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:236)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:53)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:229)
at org.junit.runners.ParentRunner.run(ParentRunner.java:309)
at cucumber.runtime.junit.FeatureRunner.run(FeatureRunner.java:70)
at cucumber.api.junit.Cucumber.runChild(Cucumber.java:93)
at cucumber.api.junit.Cucumber.runChild(Cucumber.java:37)
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:238)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:63)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:236)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:53)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:229)
at org.junit.runners.ParentRunner.run(ParentRunner.java:309)
at cucumber.api.junit.Cucumber.run(Cucumber.java:98)
at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:365)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:272)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:236)
at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:159)
at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:386)
at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:323)
at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:143)
Caused by: org.h2.jdbc.JdbcSQLException: Table "ACT_ACCOUNT" already exists; SQL statement:
CREATE TABLE PUBLIC.act_account (scope_id BIGINT(21) unsigned, id BIGINT(21) unsigned NOT NULL, name VARCHAR(255) NOT NULL, created_on TIMESTAMP DEFAULT NOW(), created_by BIGINT(21) unsigned NOT NULL, modified_on TIMESTAMP DEFAULT NOW() NOT NULL, modified_by BIGINT(21) unsigned NOT NULL, org_name VARCHAR(255) NOT NULL, org_person_name VARCHAR(255), org_email VARCHAR(255) NOT NULL, org_phone_number VARCHAR(64), org_address_line_1 VARCHAR(255), org_address_line_2 VARCHAR(255), org_address_line_3 VARCHAR(255), org_zip_postcode VARCHAR(255), org_city VARCHAR(255), org_state_province_county VARCHAR(255), org_country VARCHAR(255), parent_account_path VARCHAR(64), optlock INT unsigned, attributes CLOB, properties CLOB, CONSTRAINT PK_ACT_ACCOUNT PRIMARY KEY (id), UNIQUE (name)) [42101-192]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
at org.h2.message.DbException.get(DbException.java:179)
at org.h2.message.DbException.get(DbException.java:155)
at org.h2.command.ddl.CreateTable.update(CreateTable.java:115)
at org.h2.command.CommandContainer.update(CommandContainer.java:98)
at org.h2.command.Command.executeUpdate(Command.java:258)
at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:184)
at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:158)
at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:86)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:49)
... 49 common frames omitted
06:27:43.842 [main] ERROR o.e.k.s.l.KapuaLiquibaseClient - Error while running Liquibase scripts!
liquibase.exception.MigrationFailedException: Migration failed for change set KapuaDB/changelog-account-0.2.0.xml::changelog-account-0.2.0_createTable::eurotech:
Reason: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE PUBLIC.act_account (scope_id BIGINT(21) unsigned, id BIGINT(21) unsigned NOT NULL, name VARCHAR(255) NOT NULL, created_on TIMESTAMP DEFAULT NOW(), created_by BIGINT(21) unsigned NOT NULL, modified_on TIMESTAMP DEFAULT NOW() NOT NULL, modified_by BIGINT(21) unsigned NOT NULL, org_name VARCHAR(255) NOT NULL, org_person_name VARCHAR(255), org_email VARCHAR(255) NOT NULL, org_phone_number VARCHAR(64), org_address_line_1 VARCHAR(255), org_address_line_2 VARCHAR(255), org_address_line_3 VARCHAR(255), org_zip_postcode VARCHAR(255), org_city VARCHAR(255), org_state_province_county VARCHAR(255), org_country VARCHAR(255), parent_account_path VARCHAR(64), optlock INT unsigned, attributes CLOB, properties CLOB, CONSTRAINT PK_ACT_ACCOUNT PRIMARY KEY (id), UNIQUE (name)): Table "ACT_ACCOUNT" already exists; SQL statement:
CREATE TABLE PUBLIC.act_account (scope_id BIGINT(21) unsigned, id BIGINT(21) unsigned NOT NULL, name VARCHAR(255) NOT NULL, created_on TIMESTAMP DEFAULT NOW(), created_by BIGINT(21) unsigned NOT NULL, modified_on TIMESTAMP DEFAULT NOW() NOT NULL, modified_by BIGINT(21) unsigned NOT NULL, org_name VARCHAR(255) NOT NULL, org_person_name VARCHAR(255), org_email VARCHAR(255) NOT NULL, org_phone_number VARCHAR(64), org_address_line_1 VARCHAR(255), org_address_line_2 VARCHAR(255), org_address_line_3 VARCHAR(255), org_zip_postcode VARCHAR(255), org_city VARCHAR(255), org_state_province_county VARCHAR(255), org_country VARCHAR(255), parent_account_path VARCHAR(64), optlock INT unsigned, attributes CLOB, properties CLOB, CONSTRAINT PK_ACT_ACCOUNT PRIMARY KEY (id), UNIQUE (name)) [42101-192]
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:376)
at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:40)
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:63)
at liquibase.Liquibase.update(Liquibase.java:136)
at org.eclipse.kapua.service.liquibase.KapuaLiquibaseClient.executeMasters(KapuaLiquibaseClient.java:136)
at org.eclipse.kapua.service.liquibase.KapuaLiquibaseClient.loadResourcesStatic(KapuaLiquibaseClient.java:112)
at org.eclipse.kapua.service.liquibase.KapuaLiquibaseClient.update(KapuaLiquibaseClient.java:67)
at org.eclipse.kapua.service.user.internal.UserServiceSteps.beforeScenario(UserServiceSteps.java:209)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at cucumber.runtime.Utils$1.call(Utils.java:37)
at cucumber.runtime.Timeout.timeout(Timeout.java:13)
at cucumber.runtime.Utils.invoke(Utils.java:31)
at cucumber.runtime.java.JavaHookDefinition.execute(JavaHookDefinition.java:60)
at cucumber.runtime.Runtime.runHookIfTagsMatch(Runtime.java:223)
at cucumber.runtime.Runtime.runHooks(Runtime.java:211)
at cucumber.runtime.Runtime.runBeforeHooks(Runtime.java:201)
at cucumber.runtime.model.CucumberScenario.run(CucumberScenario.java:40)
at cucumber.runtime.junit.ExecutionUnitRunner.run(ExecutionUnitRunner.java:91)
at cucumber.runtime.junit.FeatureRunner.runChild(FeatureRunner.java:63)
at cucumber.runtime.junit.FeatureRunner.runChild(FeatureRunner.java:18)
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:238)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:63)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:236)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:53)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:229)
at org.junit.runners.ParentRunner.run(ParentRunner.java:309)
at cucumber.runtime.junit.FeatureRunner.run(FeatureRunner.java:70)
at cucumber.api.junit.Cucumber.runChild(Cucumber.java:93)
at cucumber.api.junit.Cucumber.runChild(Cucumber.java:37)
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:238)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:63)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:236)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:53)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:229)
at org.junit.runners.ParentRunner.run(ParentRunner.java:309)
at cucumber.api.junit.Cucumber.run(Cucumber.java:98)
at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:365)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:272)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:236)
at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:159)
at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:386)
at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:323)
at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:143)
Caused by: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE PUBLIC.act_account (scope_id BIGINT(21) unsigned, id BIGINT(21) unsigned NOT NULL, name VARCHAR(255) NOT NULL, created_on TIMESTAMP DEFAULT NOW(), created_by BIGINT(21) unsigned NOT NULL, modified_on TIMESTAMP DEFAULT NOW() NOT NULL, modified_by BIGINT(21) unsigned NOT NULL, org_name VARCHAR(255) NOT NULL, org_person_name VARCHAR(255), org_email VARCHAR(255) NOT NULL, org_phone_number VARCHAR(64), org_address_line_1 VARCHAR(255), org_address_line_2 VARCHAR(255), org_address_line_3 VARCHAR(255), org_zip_postcode VARCHAR(255), org_city VARCHAR(255), org_state_province_county VARCHAR(255), org_country VARCHAR(255), parent_account_path VARCHAR(64), optlock INT unsigned, attributes CLOB, properties CLOB, CONSTRAINT PK_ACT_ACCOUNT PRIMARY KEY (id), UNIQUE (name)): Table "ACT_ACCOUNT" already exists; SQL statement:
CREATE TABLE PUBLIC.act_account (scope_id BIGINT(21) unsigned, id BIGINT(21) unsigned NOT NULL, name VARCHAR(255) NOT NULL, created_on TIMESTAMP DEFAULT NOW(), created_by BIGINT(21) unsigned NOT NULL, modified_on TIMESTAMP DEFAULT NOW() NOT NULL, modified_by BIGINT(21) unsigned NOT NULL, org_name VARCHAR(255) NOT NULL, org_person_name VARCHAR(255), org_email VARCHAR(255) NOT NULL, org_phone_number VARCHAR(64), org_address_line_1 VARCHAR(255), org_address_line_2 VARCHAR(255), org_address_line_3 VARCHAR(255), org_zip_postcode VARCHAR(255), org_city VARCHAR(255), org_state_province_county VARCHAR(255), org_country VARCHAR(255), parent_account_path VARCHAR(64), optlock INT unsigned, attributes CLOB, properties CLOB, CONSTRAINT PK_ACT_ACCOUNT PRIMARY KEY (id), UNIQUE (name)) [42101-192]
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:56)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:98)
at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1491)
at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1474)
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:343)
... 45 common frames omitted
Caused by: org.h2.jdbc.JdbcSQLException: Table "ACT_ACCOUNT" already exists; SQL statement:
CREATE TABLE PUBLIC.act_account (scope_id BIGINT(21) unsigned, id BIGINT(21) unsigned NOT NULL, name VARCHAR(255) NOT NULL, created_on TIMESTAMP DEFAULT NOW(), created_by BIGINT(21) unsigned NOT NULL, modified_on TIMESTAMP DEFAULT NOW() NOT NULL, modified_by BIGINT(21) unsigned NOT NULL, org_name VARCHAR(255) NOT NULL, org_person_name VARCHAR(255), org_email VARCHAR(255) NOT NULL, org_phone_number VARCHAR(64), org_address_line_1 VARCHAR(255), org_address_line_2 VARCHAR(255), org_address_line_3 VARCHAR(255), org_zip_postcode VARCHAR(255), org_city VARCHAR(255), org_state_province_county VARCHAR(255), org_country VARCHAR(255), parent_account_path VARCHAR(64), optlock INT unsigned, attributes CLOB, properties CLOB, CONSTRAINT PK_ACT_ACCOUNT PRIMARY KEY (id), UNIQUE (name)) [42101-192]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
at org.h2.message.DbException.get(DbException.java:179)
at org.h2.message.DbException.get(DbException.java:155)
at org.h2.command.ddl.CreateTable.update(CreateTable.java:115)
at org.h2.command.CommandContainer.update(CommandContainer.java:98)
at org.h2.command.Command.executeUpdate(Command.java:258)
at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:184)
at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:158)
at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:86)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:49)
... 49 common frames omitted